Executive Summary
3
Troubles that occurred during the project:
- The Package Failed due to the error – Data conversion of the Location 1 returned status value 4 and status text “ Text was truncated or one …..” resolved this by changing the output column length to 4000 for the Location 1 column in the Source.
- Data cleanup for the Victim Business Name –the column has many special characters and address or date instead of name of the business, for example column has “7-Jul” instead of 7 Eleven … resolved this issue with update SQL Query.

Designing a Data
Warehouse for Cyber Crimes
https://commons.erau.edu/cgi/viewcontent.cgi?article=1001&context=adfsl